
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspAccessRole_UPDATE
(
@roleId int = null,
@name nvarchar(50) = null,
@description nvarchar(250) = null,
@isDeleted bit = null,
@createDate datetime = null,
@lastModifiedDate datetime = null
)
AS

UPDATE
  [dbo].[AccessRole]
SET
  [Name] = @name,
  [Description] = @description,
  [IsDeleted] = @isDeleted,
  [CreateDate] = @createDate,
  [LastModifiedDate] = @lastModifiedDate
WHERE
  [RoleId] = @roleId

GO
